// Decompiled by GOOSIN CO,LTD Copyright 2010 Pavel Kouznetsov.
// home page: http://www.Goosin.net
// Decompiler options: packimports(3) fieldsfirst ansi space 
// Source File Name:   change_picture.java

package hr.file;

import include.get_sql.getInsertSql;
import include.nseer_cookie.GetWorkflow;
import include.nseer_cookie.exchange;
import include.nseer_db.nseer_db_backup1;
import include.operateDB.CdefineUpdate;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.*;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.*;
import javax.servlet.jsp.JspFactory;
import validata.ValidataTag;

public class change_picture extends HttpServlet
{

	ServletContext application;
	HttpSession session;
	nseer_db_backup1 erp_db;

	public change_picture()
	{
		erp_db = null;
	}

	public synchronized void service(HttpServletRequest request, HttpServletResponse response)
		throws IOException, ServletException
	{
		HttpSession dbSession = request.getSession();
		JspFactory _jspxFactory = JspFactory.getDefaultFactory();
		javax.servlet.jsp.PageContext pageContext = _jspxFactory.getPageContext(this, request, response, "", true, 8192, true);
		ServletContext dbApplication = dbSession.getServletContext();
		try
		{
			HttpSession session = request.getSession();
			PrintWriter out = response.getWriter();
			nseer_db_backup1 hr_db = new nseer_db_backup1(dbApplication);
			getInsertSql getInsertSql = new getInsertSql();
			ValidataTag vt = new ValidataTag();
			if (hr_db.conn((String)dbSession.getAttribute("unit_db_name")))
			{
				String human_ID = request.getParameter("human_ID");
				String human_name = request.getParameter("human_name");
				String human_address = request.getParameter("human_address");
				String human_title_class = request.getParameter("human_title_class");
				String human_bank = request.getParameter("human_bank");
				String human_account = request.getParameter("human_account");
				String human_tel = request.getParameter("human_tel");
				String human_home_tel = request.getParameter("human_home_tel");
				String human_postcode = request.getParameter("human_postcode");
				String changer = request.getParameter("changer");
				String human_cellphone = request.getParameter("human_cellphone");
				String idcard = request.getParameter("idcard");
				String SIN = request.getParameter("SIN");
				String religion = request.getParameter("religion");
				String party = request.getParameter("party");
				String race = request.getParameter("race");
				String nationality = request.getParameter("nationality");
				String age = request.getParameter("age");
				String sex = request.getParameter("sex");
				String speciality = request.getParameter("speciality");
				String hobby = request.getParameter("hobby");
				String birthday = request.getParameter("birthday");
				if (birthday.equals(""))
					birthday = "1800-01-01";
				String birthplace = request.getParameter("birthplace");
				String human_email = request.getParameter("human_email");
				String educated_degree = request.getParameter("educated_degree");
				String educated_years = request.getParameter("educated_years");
				String educated_major = request.getParameter("educated_major");
				String change_time = request.getParameter("change_time");
				String bodyc = new String(request.getParameter("remark").getBytes("UTF-8"), "UTF-8");
				String remark = exchange.toHtml(bodyc);
				String bodya = new String(request.getParameter("history_records").getBytes("UTF-8"), "UTF-8");
				String history_records = exchange.toHtml(bodya);
				String bodyb = new String(request.getParameter("family_membership").getBytes("UTF-8"), "UTF-8");
				String family_membership = exchange.toHtml(bodyb);
				String lately_change_time = request.getParameter("lately_change_time");
				String file_change_amount = request.getParameter("file_change_amount");
				String salary_standard_ID = "";
				String salary_standard_name = "";
				String salary_sum = "";
				String salary_standard = request.getParameter("salary_standard");
				for (StringTokenizer tokenTO6 = new StringTokenizer(salary_standard, "/"); tokenTO6.hasMoreTokens();)
				{
					salary_standard_ID = tokenTO6.nextToken();
					salary_standard_name = tokenTO6.nextToken();
					salary_sum = tokenTO6.nextToken();
				}

				int change_amount = Integer.parseInt(file_change_amount) + 1;
				String column_group = getInsertSql.sql((String)dbSession.getAttribute("unit_db_name"), "hr_file");
				if (vt.validata((String)dbSession.getAttribute("unit_db_name"), "hr_file", "human_ID", human_ID, "check_tag").equals("1"))
					try
					{
						String sqll = (new StringBuilder("insert into hr_file_dig(")).append(column_group).append(") select ").append(column_group).append(" from hr_file where human_ID='").append(human_ID).append("'").toString();
						hr_db.executeUpdate(sqll);
						String sql8 = (new StringBuilder("update hr_file set human_name='")).append(human_name).append("',human_address='").append(human_address).append("',human_title_class='").append(human_title_class).append("',human_bank='").append(human_bank).append("',human_account='").append(human_account).append("',human_tel='").append(human_tel).append("',human_home_tel='").append(human_home_tel).append("',human_postcode='").append(human_postcode).append("',changer='").append(changer).append("',educated_degree='").append(educated_degree).append("',educated_years='").append(educated_years).append("',educated_major='").append(educated_major).append("',change_time='").append(change_time).append("',salary_standard_ID='").append(salary_standard_ID).append("',salary_standard_name='").append(salary_standard_name).append("',salary_sum='").append(salary_sum).append("',family_membership='").append(family_membership).append("',history_records='").append(history_records).append("',remark='").append(remark).append("',human_cellphone='").append(human_cellphone).append("',idcard='").append(idcard).append("',SIN='").append(SIN).append("',religion='").append(religion).append("',race='").append(race).append("',nationality='").append(nationality).append("',party='").append(party).append("',age='").append(age).append("',birthday='").append(birthday).append("',birthplace='").append(birthplace).append("',sex='").append(sex).append("',speciality='").append(speciality).append("',hobby='").append(hobby).append("',lately_change_time='").append(lately_change_time).append("',file_change_amount='").append(change_amount).append("',human_email='").append(human_email).append("',check_tag='0',change_tag='1' where human_ID='").append(human_ID).append("'").toString();
						hr_db.executeUpdate(sql8);
						CdefineUpdate CdefineUpdate = new CdefineUpdate();
						sql8 = CdefineUpdate.update("hr_file", "human_ID", human_ID, request);
						hr_db.executeUpdate(sql8);
						String sql9 = (new StringBuilder("update security_users set human_name='")).append(human_name).append("' where human_ID='").append(human_ID).append("'").toString();
						hr_db.executeUpdate(sql9);
						String sql10 = (new StringBuilder("update security_license set human_name='")).append(human_name).append("' where human_ID='").append(human_ID).append("'").toString();
						hr_db.executeUpdate(sql10);
						List rsList = GetWorkflow.getList(hr_db, "hr_config_workflow", "01");
						String elem[] = new String[3];
						if (rsList.size() == 0)
						{
							String sql = (new StringBuilder("update hr_file set check_tag='1' where human_ID='")).append(human_ID).append("'").toString();
							hr_db.executeUpdate(sql);
						} else
						{
							String sql = (new StringBuilder("delete from hr_workflow where object_ID='")).append(human_ID).append("' and type_id='01'").toString();
							hr_db.executeUpdate(sql);
							sql = (new StringBuilder("update hr_file set check_tag='0' where human_ID='")).append(human_ID).append("'").toString();
							hr_db.executeUpdate(sql);
							for (Iterator ite = rsList.iterator(); ite.hasNext(); hr_db.executeUpdate(sql))
							{
								elem = (String[])ite.next();
								sql = (new StringBuilder("insert into hr_workflow(config_id,object_ID,type_id,describe1,describe2) values ('")).append(elem[0]).append("','").append(human_ID).append("','01','").append(elem[1]).append("','").append(elem[2]).append("')").toString();
							}

						}
						response.sendRedirect((new StringBuilder("hr/file/change_choose_picture.jsp?human_ID=")).append(human_ID).toString());
					}
					catch (Exception ex)
					{
						out.println((new StringBuilder("error")).append(ex).toString());
					}
				else
					response.sendRedirect("hr/file/change_picture_a.jsp");
				hr_db.commit();
				hr_db.close();
			} else
			{
				response.sendRedirect("error_conn.htm");
			}
		}
		catch (Exception exception) { }
	}
}
